/**
 * Copyright (c) 2013, Redsolution LTD. All rights reserved.
 * 
 * This file is part of Xabber project; you can redistribute it and/or
 * modify it under the terms of the GNU General Public License, Version 3.
 * 
 * Xabber is distributed in the hope that it will be useful, but
 * WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
 * See the GNU General Public License for more details.
 * 
 * You should have received a copy of the GNU General Public License,
 * along with this program. If not, see http://www.gnu.org/licenses/.
 */
package com.digitalbuana.smiles.data.message.phrase;

import android.content.ContentValues;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.net.Uri;
import android.provider.BaseColumns;

import com.digitalbuana.smiles.data.AbstractTable;
import com.digitalbuana.smiles.data.DatabaseManager;

/**
 * Storage with phrase notification settings.
 * 
 * @author alexander.ivanov
 */
class PhraseTable extends AbstractTable {

	private static final class Fields implements BaseColumns {

		private Fields() {
		}

		/**
		 * Text pattern.
		 */
		public static final String VALUE = "value";

		/**
		 * JID pattern.
		 */
		public static final String USER = "user";

		/**
		 * Contact list group pattern.
		 */
		public static final String GROUP = "_group";

		/**
		 * Whether text should be processed as regexp.
		 */
		public static final String REGEXP = "regexp";

		/**
		 * Used sound.
		 */
		public static final String SOUND = "sound";

	}

	private static final String NAME = "phrase";
	private static final String[] PROJECTION = new String[] { Fields._ID,
			Fields.VALUE, Fields.USER, Fields.GROUP, Fields.REGEXP,
			Fields.SOUND, };

	private final DatabaseManager databaseManager;

	private final static PhraseTable instance;

	static {
		instance = new PhraseTable(DatabaseManager.getInstance());
		DatabaseManager.getInstance().addTable(instance);
	}

	public static PhraseTable getInstance() {
		return instance;
	}

	private PhraseTable(DatabaseManager databaseManager) {
		this.databaseManager = databaseManager;
	}

	@Override
	public void create(SQLiteDatabase db) {
		String sql;
		sql = "CREATE TABLE " + NAME + " (" + Fields._ID
				+ " INTEGER PRIMARY KEY," + Fields.VALUE + " TEXT,"
				+ Fields.USER + " TEXT," + Fields.GROUP + " TEXT,"
				+ Fields.REGEXP + " INTEGER," + Fields.SOUND + " TEXT);";
		DatabaseManager.execSQL(db, sql);
	}

	@Override
	public void migrate(SQLiteDatabase db, int toVersion) {
		super.migrate(db, toVersion);
		String sql;
		switch (toVersion) {
		case 63:
			sql = "CREATE TABLE phrase (_id INTEGER PRIMARY KEY,"
					+ "value TEXT," + "regexp INTEGER," + "sound TEXT);";
			DatabaseManager.execSQL(db, sql);
			break;
		case 64:
			sql = "ALTER TABLE phrase ADD COLUMN user TEXT;";
			DatabaseManager.execSQL(db, sql);
			sql = "UPDATE phrase SET user = \"\";";
			DatabaseManager.execSQL(db, sql);
			sql = "ALTER TABLE phrase ADD COLUMN _group TEXT;";
			DatabaseManager.execSQL(db, sql);
			sql = "UPDATE phrase SET _group = \"\";";
			DatabaseManager.execSQL(db, sql);
			break;
		default:
			break;
		}
	}

	long write(Long id, String value, String user, String group,
			boolean regexp, Uri sound) {
		SQLiteDatabase db = databaseManager.getWritableDatabase();
		ContentValues values = new ContentValues();
		values.put(Fields.VALUE, value);
		values.put(Fields.USER, user);
		values.put(Fields.GROUP, group);
		values.put(Fields.REGEXP, regexp ? 1 : 0);
		values.put(Fields.SOUND, sound.toString());
		if (id == null)
			return db.insert(NAME, Fields.VALUE, values);
		db.update(NAME, values, Fields._ID + " = ?",
				new String[] { String.valueOf(id) });
		return id;
	}

	void remove(long id) {
		SQLiteDatabase db = databaseManager.getWritableDatabase();
		db.delete(NAME, Fields._ID + " = ?",
				new String[] { String.valueOf(id) });
	}

	@Override
	protected String getTableName() {
		return NAME;
	}

	@Override
	protected String[] getProjection() {
		return PROJECTION;
	}

	@Override
	protected String getListOrder() {
		return Fields._ID;
	}

	static long getId(Cursor cursor) {
		return cursor.getLong(cursor.getColumnIndex(Fields._ID));
	}

	static String getValue(Cursor cursor) {
		return cursor.getString(cursor.getColumnIndex(Fields.VALUE));
	}

	static String getUser(Cursor cursor) {
		return cursor.getString(cursor.getColumnIndex(Fields.USER));
	}

	static String getGroup(Cursor cursor) {
		return cursor.getString(cursor.getColumnIndex(Fields.GROUP));
	}

	static boolean isRegexp(Cursor cursor) {
		return cursor.getLong(cursor.getColumnIndex(Fields.REGEXP)) != 0;
	}

	static Uri getSound(Cursor cursor) {
		return Uri.parse(cursor.getString(cursor.getColumnIndex(Fields.SOUND)));
	}

}